package com.groupseven.backend.mapper;

import com.groupseven.backend.domain.Echarts.EchartsData;
import com.groupseven.backend.domain.Echarts.EchartsDict;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface EchartsMapper {

    List<EchartsData> getProgramsQuantityByUsername();
    List<EchartsData> getPapersQuantityByUsername();
    List<EchartsData> getPatentsQuantityByUsername();
    List<EchartsData> getAwardsQuantityByUsername();

    List<EchartsData> getProgramsQuantityOrderByAffliation();
    List<EchartsData> getPapersQuantityOrderByAffliation();
    List<EchartsData> getPatentsQuantityOrderByAffliation();
    List<EchartsData> getAwardsQuantityOrderByAffliation();
    List<EchartsDict> getLevelDict();
    List<String> getAffiliations();
}
